﻿CREATE TABLE [dbo].[ProjectBudget] (
    [Id]                     UNIQUEIDENTIFIER NOT NULL,
    [LineNumber]             NVARCHAR (50)    NULL,
    [Description]            NTEXT            NULL,
    [BudgetCategoryId]       UNIQUEIDENTIFIER NULL,
    [TotalBudget]            MONEY            NOT NULL,
    [TotalCommitted]         MONEY            NULL,
    [TotalPosted]            MONEY            NULL,
    [RemainingBalance]       MONEY            NULL,
    [MasterBudgetCategoryId] UNIQUEIDENTIFIER NULL
);

